﻿CREATE PROCEDURE dbo.SP_MemberJobs_Insert
	@EmployedFrom DateTime   =  NULL 
		, @EmployedTo DateTime   =  NULL 
		, @Employeer NVarChar (50)  =  NULL 
		, @IsCurrentJob Bit   =  NULL 
		, @MemberId Int   =  NULL 
		, @Position NVarChar (50)  =  NULL 
		AS
			INSERT INTO MemberJobs
			(
									EmployedFrom
												,EmployedTo
												,Employeer
												,IsCurrentJob
												,MemberId
												,Position
									)
			Values(
									@EmployedFrom
												,@EmployedTo
												,@Employeer
												,@IsCurrentJob
												,@MemberId
												,@Position
						)
			return @@identity